2013-03-25 - 5910.200 - Rel Notes - Contracts - Release 013 #BIReleases2013

Release Notes:

‍5910.200 - Contracts - OSA915

‍Admin Info

Purpose
 Including Contract Information in OSA900 report
Release No
 013
Submitted
 03-25-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Mallareddy D
Object(s) Tested By
 Praveen Guntuka

‍

Report Name

OSA915 - Open Orders by Sales Org, SBU, Sport, License, Team, Style and Material.

‍BEx Query

ZMP_OPASA_Q031

NEC Crystal Reports Standards Check

1. OSA915 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA915 NEC CR checklist has been sent to NEC and also attached here for reference.
OSA915 NEC CR Standard Check List.xlsx

‍Dynamic Group 1:

‍Test Conducted

Dynamic Grouping Parameter(1) and Group Name: SBU > Sport > License > Team > Style > Material

‍Summary Level Check

‍Test Conducted

Group: Sales Orgs - 5th & Ocean Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 1,470,361
 1,470,361
 Pass
2
 Sales Org Currency
 13,728,458
 13,728,457.70
 Pass
3
 Corporate Currency
 13,728,458
 13,728,457.70
 Pass
Group: Sales Orgs - EMEA Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 1,798,508
 1,798,508
 Pass
2
 Sales Org Currency
 15,572,702
 15,572,701.61
 Pass
3
 Corporate Currency
 23,715,678
 23,715,677.43
 Pass

‍Second Level Check

‍Test Conducted

Group: APAC Sales > Accessories
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 929
 929
 Pass
2
 Sales Org Currency
 90,854
 90,853.89
 Pass
3
 Corporate Currency
 11,715
 11,714.92
 Pass
Group: German Sales > KIDS
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 48
 48
 Pass
2
 Sales Org Currency
 396
 396.00
 Pass
3
 Corporate Currency
 524
 523.99
 Pass

‍Third Level Check

‍Test Conducted

Group: Australia > ENTERTAINMENT > ANIMATED CHARACTER
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 45
 45
 Pass
2
 Sales Org Currency
 938
 937.50
 Pass
3
 Corporate Currency
 961
 960.66
 Pass
Group : EMES Sales > WOMENS > BASEBALL
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 39,303
 39,303
 Pass
2
 Sales Org Currency
 310,338
 310,338.40
 Pass
3
 Corporate Currency
 472,616
 472,616.28
 Pass

‍Fourth Level Check

‍Test Conducted

Group: Mexico Sales > FANGEAR > BASEBALL > MLB PROPERTIES
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 20,907
 20,907
 Pass
2
 Sales Org Currency
 3,720,566
 3,720,566.46
 Pass
3
 Corporate Currency
 291,692
 291,692.41
 Pass
‍
Group: APAC Sales > BASEBALL - ON FIELD > BASEBALL > WORLD BASEBALL CLASSIC
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 143
 143
 Pass
2
 Sales Org Currency
 14,639
 14,638.63
 Pass
3
 Corporate Currency
 1,888
 1,888.40
 Pass

Fifth Level Check

‍Test Conducted

Group: Australia Sales > NEW ERA BRANDED > NONE > NEW ERA BRANDED > NON LICENSED
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 1,918
 1,918
 Pass
2
 Sales Org Currency
 38,145
 38,145.47
 Pass
3
 Corporate Currency
 39,088
 39,087.66
 Pass
Group: Canada Sales > VICTORIAS SECRET > BASEBALL > MLB PROPERTIES > TORONTO BLUE JAYS
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 975
 975
 Pass
2
 Sales Org Currency
 15,532
 15,532.12
 Pass
3
 Corporate Currency
 15,254
 15,254.10
 Pass
‍

Sixth Level Check

‍Test Conducted

Group: German Sales > ACTION > NONE > NON LICENSED > NONE > 3930
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 59
 59
 Pass
2
 Sales Org Currency
 348
 348.10
 Pass
3
 Corporate Currency
 461
 460.61
 Pass
Group: 5th & Ocean Sales > WOMENS APPAREL - UPSTAIRS > COLLEGE > INDEPENDENT COLLEGE > INDIANA HOSSIERS > PANTS
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 1,713
 1,713
 Pass
2
 Sales Org Currency
 18,226
 18,226.32
 Pass
3
 Corporate Currency
 18,226
 18,226.32
 Pass

Seventh Level Check

‍Test Conducted

Group: United State Sales > FANGEAR > HOCKEY > AMERICAN HOCKY LEAGUE > TEXAS STARS > 940 > 10871076 OPUS STRIKES BACK TEXSTA TEAM
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 144
 144
 Pass
2
 Sales Org Currency
 1,224
 1,224.00
 Pass
3
 Corporate Currency
 1,224
 1,224.00
 Pass
Group: APAC Sales > LIFESTYLE > FOOTBALL > NFL PROPERTIES > BUFFALO BILLS > 5950 > 75166718 TRI-PAN 59FIFTY BUFBIL TEAM
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 20
 20
 Pass
2
 Sales Org Currency
 2,109
 2,109.47
 Pass
3
 Corporate Currency
 272
 272.00
 Pass

‍Dynamic Group 2:

‍Test Conducted

Dynamic Grouping Parameter(2) and Group Name: Sport > License > Team > Style > Material

‍Summary Level Check

‍Test Conducted

Group: Sales Orgs - APAC Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 75,608
 75,608
 Pass
2
 Sales Org Currency
 8,122,750
 8,122,749.72
 Pass
3
 Corporate Currency
 1,047,367
 1,047,366.96
 Pass
Group: Sales Orgs - Mexico sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 371,983
 371,983
 Pass
2
 Sales Org Currency
 80,236,051
 80,236,051.30
 Pass
3
 Corporate Currency
 6,290,506
 6,290,506.42
 Pass

‍Second Level Check

‍Test Conducted

Group: Australia Sales > CRICKET
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 11
 11
 Pass
2
 Sales Org Currency
 165
 165.00
 Pass
3
 Corporate Currency
 169
 169.08
 Pass
Group: NEC Korea Sales > ENTERTAINMENT
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 454
 454
 Pass
2
 Sales Org Currency
 9,993,568
 9,993,568.00
 Pass
3
 Corporate Currency
 8,994
 8,994.21
 Pass

Third Level Check

‍Test Conducted

Group: German Sales > ANIMATED CHARACTER > WARNER BROS
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 60
 60
 Pass
2
 Sales Org Currency
 827
 827.10
 Pass
3
 Corporate Currency
 1,094
 1,094.42
 Pass
Group: Latin America Sales > FOOTBALL > NFL PROPERTIES
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 11,366
 11,366
 Pass
2
 Sales Org Currency
 128,202
 128,202.02
 Pass
3
 Corporate Currency
 128,202
 128,202.02
 Pass
‍

Fourth Level Check

‍Test Conducted

Group: Mexico Sales > BASEBALL > WORLD BESEBALL CLASSIC > WBC MEXICO
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 26
 26
 Pass
2
 Sales Org Currency
 3,541
 3,540.68
 Pass
3
 Corporate Currency
 278
 277.59
 Pass
Group: EMEA Sales > SOCCER > NON LICENSED > NONE
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 8,817
 8,817
 Pass
2
 Sales Org Currency
 43,671
 43,670.88
 Pass
3
 Corporate Currency
 66,505
 66,504.51
 Pass

Fifth Level Check

‍Test Conducted

Group: 5th & Ocean Sales > RACING > NON LICENSE > NONE > SHORTS
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 3
 3
 Pass
2
 Sales Org Currency
 25
 24.75
 Pass
3
 Corporate Currency
 25
 24.75
 Pass
Group: Latin America Sales > ANIMATED CHARACTER > DISNEY > MICKEY MOUSE > 950
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 270
 270
 Pass
2
 Sales Org Currency
 2,299
 2,299.20
 Pass
3
 Corporate Currency
 2,299
 2,299.20
 Pass

Sixth Level Check

‍Test Conducted

Group: United State Sales > GOLF > US GOLF ASSOCIATION > US OPEN MERION > VISOR > 10871825 1070085 PV WHITE PIPE UP VISOR
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 228
 228
 Pass
2
 Sales Org Currency
 1,776
 1,776.12
 Pass
3
 Corporate Currency
 1,776
 1,776.12
 Pass
Group: EMEA Sales > ANIMATED CHARACTER > WARNER BROS > SCOOBY DOO > KNIT > 10850535 WOVEN BIGGIE SCOOBY DOO OFFICIAL
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Quantity
 36
 36
 Pass
2
 Sales Org Currency
 69
 68.76
 Pass
3
 Corporate Currency
 105
 104.72
 Pass

‍Reference Document (Specification)

2013-03-15 - 5910.200 - Spec - Contract Reports
Open Orders by Sales Org, SBU, Sport, License, Team, Style and Material